Excel 2016 - Logical, Informational and Financial Functions, Text Functions and Data Tables
      The "Excel 2016 - Logical, Informational and Financial Functions, Text Functions and Data Tables" lesson covers the following topics:
  • Logical and Informational Functions
  • More Logical Functions
  • Financial Functions and Data Tables
  • Text Functions
      
      Logical and Informational Functions      
      Upon successful completion you will be able to:

1. Use the IF Function;
2. Use the OR Function;
3. Use the AND Function;
4. Use Help for Error Messages;
5. Use Nested IF Functions;
6. Understand IS Functions;
7. Use the ISERROR Function.		      
      More Logical Functions      
      Upon successful completion you will be able to:

1. Use the SUMIF Function;
2. Use the COUNTIF Function;
3. Use the AVERAGEIF Function.		      
      Financial Functions and Data Tables      
      Upon successful completion you will be able to:

1. Understand Financial Arguments;
2. Use the FV Function;
3. Use the PMT Function;
4. Use the NPV Function;
5. Use the Pv Argument;
6. Use the RATE Function;
7. Use NPV Function;
8. Use the Guess Argument;
9. Use Data Tables.		      
      Text Functions      
      Upon successful completion you will be able to:

1. Understand Text Functions;
2. Use the CONCATENATE Function;
3. Use the LOWER Function;
4. Use the LEFT Function;
5. Add Function Arguments;
6. Use the PROPER Function;
7. Use the UPPER Function
8. Understand the TRIM Function.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2016 - Logical, Informational and Financial Functions, Text Functions and Data Tables :
Program Training Courses - Microsoft Excel 2016 :
Office Suite Training Courses - Microsoft Office 2016 :
© 2017 Online Training Masters